Aside

Data Tools & Languages

Additional Skills

Education

Double Bachelor of Arts in
Psychology & Philosophy

Victoria University of
Wellington

November, 2019

Wellington, NZ

Certification

Professional Certificate in Data Analytics

Google Careers Certification

June, 2021

Coursera

Disclaimer

Page 1 of 1

Main

Kyle PATRICK Simpson

ETL/ELT Pipeline Support Specialist   |   Researrch Analyst   |   Data Technician

Data analyst with 5+ years experience supporting data pipelines, automating workflows, and integrating datasets using SQL, Python, R, and Excel/Googlesheets. Strong focus on data quality, reporting accuracy, and translating complex data into operational decisions. Experience across Non-profit, Hospitality/Retail, Public Health, and Environmental Research sectors.

Relevant Work History

Inventory & Quality Assurance Analyst

M2 by Matcha Matcha

Toronto, Ont

2024

  • Engineered a data structure integrating POS, Sales, and Recipes to feed downstream reporting and interactive dashboards.
  • Drove operational Quality Assurance using data for compliance testing on production outputs and service standards.
  • Created dashboards and reports with integrated data, optimizing ordering, and reducing waste.

Data Migration Technician

Lions Foundation of Canada Dog Guides

Oakville, Ont

2022

  • Managed ETL consolidation into Salesforce, performing data mapping and ensuring 100% data integrity.
  • Implemented Excel VBA automated workflow for validation, reducing errors and improving efficiency by 33%.
  • Authored SOPs and documentation for data entry, assessing data quality, and troubleshooting workflows.

Data & Systems Administrator

Accident Compensation Commission of New Zealand

Dunedin, NZ

2022 - 2021

  • Executed primary triage on data quality tickets, identifying anomalies and discrepancies in accident claims and healthcare data.
  • Systematically documented known issues and bottlenecks within the data pipeline to guide resolution.
  • Collaborated across teams to fix critical data issues, mitigating downstream implications on accident claim cover decisions.

Managing Director / Data Systems Consultant

Bar Squire Beverage Consultancy Services

Wellington, NZ

2021 - 2020

  • Created a centralized database, integrating data from multiple sources to inform data-driven consultancy to businesses and events.
  • Applied SQL and Python for analysis and troubleshooting system issues and data structures of client/company systems.
  • Provided advisory services on data systems and reporting, translating raw data into business intelligence.

Research Analyst

Greenback Ltd.

Auckland, NZ

2020 - 2019

  • Led data acquisition via API calls and web scraping, expanding the knowledge base for research.
  • Performed extensive data cleaning and validation, preparing datasets for dashboards and reporting.
  • Partnered with engineers on data curation and analysis, optimizing data for application development.